package com.alibaba.ai.dao;

import com.alibaba.ai.entity.Ranking;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface RankingMapper {
    //小区涨跌排行榜
    @Select("selec e_xarea_name,C_PRICE,C_COMPARED,C_PERCENTAGE from C_RANKING,E_XAREA where C_RANKING.C_XAREA_ID=E_XAREA.id and order by C_PERCENTAGE DESC")
    List<Ranking> selectRanking(String eXareaName, String cPrice, String cCompared, String cPercentage);
}
